{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["README"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"README","index":0,"n_rows":36,"n_cols":14,"rows_kept":36,"cut":false,"hidden":false,"merged":[[22,1,27,7]]}
[]
[null,"Current Diabetic Patients",null,null,null,null,null,null,null,null,"Search Criteria = Last one of the below:"]
[null,null,null,null,null,null,null,null,null,null,"Description","Time","Entity","Codes"]
[null,null,null,null,null,null,null,null,null,null,"Active Patients","Ever",null,"Applied and Permanent Only"]
[null,null,null,null,null,null,null,null,null,null,"Active Diabetic*","Ever","All Clinical, Problems","C10..%, C109J00, C109K00, C10C.%, C10D.%, C10E%  (Excluding C10F8%), C10F%, C10G%, C10H%, C10M%, C10N%, C10P%, C10Q.%, PKyP.%"]
[null,null,null,null,null,null,null,null,null,null,"Diabetic Diagnosis","Ever","All Clinical, Problems","C10..%, C109J00, C109K00, C10C.%, C10D.%, C10E%  (Excluding C10F8%), C10F%, C10G%, C10H%, C10M%, C10N%, C10P%, C10Q.%, PKyP.%"]
[null,"To import groups of patients back into Vision, use the \"Patient Group Import App\"",null,null,null,null,null,null,null,null,"Diabetic Register","Ever","Diabetic Register","C10..%, C109J00, C109K00, C10C.%, C10D.%, C10E%  (Excluding C10F8%), C10F%, C10G%, C10H%, C10M%, C10N%, C10P%, C10Q.%, PKyP.%"]
[null,"Instructions may be found via this link: ",null,null,null,null,null,null,null,null,"Diabetes Resolved","Ever","All Clinical, Problems","21263%, 212H.% (Excluding Recall entity)"]
[null,null,null,null,null,null,null,null,null,null,"Retinal Screening","Latest","All Clinical, All Tests","58C1.%, 3129.%, 312F.%, 9N2f.%, 31283%, 68A7.%, 68A8.%"]
[null,null,null,null,null,null,null,null,null,null,"*Housebound","Latest","All Clinical","13CA%, 13CV%, 13CW% (Excluding Recall entity)"]
[null,"NOTE:",null,null,null,null,null,null,null,null,"Review","Latest","Diabetes Annual Check"]
[null,"This will only work if Vision is on DLM485 or above.\n",null,null,null,null,null,null,null,null,"Earliest Future Appt",">= today","Appointments","All"]
[null,"Excel 2010 - Please \"Enable Content\" if a security Warning is displayed\n",null,null,null,null,null,null,null,null,"Main Address","Latest","Registration"]
[null,null,null,null,null,null,null,null,null,null,"Email Consent","Latest","All Clinical","9NdS.%, 9Ndy.% (Excluding Recall entity)"]
[null,"Excel 2007 - Click the Options button and enable both Macros and Data Connection\n",null,null,null,null,null,null,null,null,"SMS Consent","Latest","All Clinical","9NdP.%, 9NdQ.% (Excluding Recall entity)"]
[null,"Excel 2003 - Not supported\n",null,null,null,null,null,null,null,null,"Tel Consent","Latest","All Clinical","9Ndi.%, 9Ndv.% (Excluding Recall entity)"]
[null,null,null,null,null,null,null,null,null,null,"Death","Ever","All Clinical","22J%, 94%, R2…12, R21%, 8HG%, ZV68011 (Excluding 94Z0%, 94Z1%, 94Z2%, 94Z3%, 94Z4%, 94Z5%, 94Z6%, 94Z7%, 94Z8%, 94Z9%, 94ZA%, 94ZB%, 94ZC%, 94ZD%, 94ZE%, 94ZF%, 94ZG% and Recall entity)"]
[null,"Current Version: 1.1"]
[null,"Last updated: 17/10/2019",null,null,null,null,null,null,null,null,"*Active Diabetic Rules"]
[null,"Written by: Bradley Sieve",null,null,null,null,null,null,null,null,"A patient line will be removed if:"]
[null,null,null,null,null,null,null,null,null,null,"1.  Latest diabetic register end date is greater than latest diagnosis date"]
[null,"Disclaimer",null,null,null,null,null,null,null,null,"2.  Diabetes resolved date if greater than the latest diagnosis"]
[null,"In using this Microsoft Excel report you hereby acknowledge that the software cannot be guaranteed error free and may also be subject to how data is being recorded by your practice, and further acknowledge that the existence of any such errors shall not make Vision responsible for any actions you carry out based on these results.\n",null,null,null,null,null,null,null,null,"3.  Earliest diagnosis end date is greater than the latest diagnosis date"]
[]
[null,null,null,null,null,null,null,null,null,null,"*Highlighted in RED text"]
[null,null,null,null,null,null,null,null,null,null,"Any patient housebound or temporariliy housebound or care is provided by hospital"]
[null,null,null,null,null,null,null,null,null,null,"Use the column filter to show/hide these rows"]
[]
[null,null,null,null,null,null,null,null,null,null,"*Death Rules"]
[null,null,null,null,null,null,null,null,null,null,"•  Any diabetic patient with a death entry in their record will be displayed with a highlighted ORANGE line"]
[null,null,null,null,null,null,null,null,null,null,"•  These lines should be filtered out or deleted from your final patient list"]
[null,null,null,null,null,null,null,null,null,null,"Use the column filter to show/hide these rows"]
[]
[]
[null,"Update 17/10/2019 - v1.1"]
[null,"Fix in code as producing wrong count of patients"]